{"text_format":"1","workbook":"xlsx","n_sheets":35,"sheets":["Introduction","Tool Guide","Inputs","WW Demand and Collection","Technologies - Input cost","Other resources from WW","WWTP-Capacity & Tech. Selection","Revenue Earned","Economic Analysis","Summary Sheet","SA NPV WSP","SA PBP WSP","SA NPV WSP with tertiary","SA PBP WSP with tertiary","SA NPV ASP","SA PBP ASP","SA NPV ASP with tertiary","SA PBP ASP with tertiary","SA NPV SBR","SA PBP SBR","SA NPV SBR with tertiary","SA PBP SBR with tertiary","SA NPV MBBR","SA PBP MBBR","SA NPV MBBR with tertiary","SA PBP MBBR with tertiary","SA NPV MBR","SA PBP MBR","SA NPV UASB","SA PBP UASB","Tool","Sheet1","Assumptions for Sens Analysis","SA of technologies against NPV","SA of technologies against PBP"],"not_rendered":{"charts":12,"images":2,"macros":1,"external_links":0,"defined_names":26,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Tool Description","The purpose of the tool is to provide a quick economic assessment for the practitioners about a wastewater circular economy intervention.A whole set of technologies today exist to treat wastewater and recover water, energy or nutrients. While it provides diversity of choice to select the set of technologies suitable to a local context, it also increases the complexity for practitioners to make decisions. In order to facilitate the decision making for the technology, this practitioner guide is accompanied by an MS Excel based economic assessment tool. In the tool, practitioners have the option to select suitable treatment technology & resource recovery options. Practitioners can provide their desired payback on investment as an input, and the tool can determine the potential tariff at which the recycled water can be sold to the industry. The tool also provides the net present value of the intervention. The tool is designed to have sufficient flexibility for the users to input values as per their local context, however, it uses default values in case the user wants to retain benchmark numbers.\n\n It does not omit the need of a detailed budgeting exercise for the intervention, which would determine the final cost of the project. However, it provides an initial ball-park estimate about the potential costs and revenues.\n"]
[null,"Contributors","Rudresh Sugam; Abhishek Jain; Kangkanika Neog"]
[null,"Contact Details","kangkanika.neog@ceew.in; abhishek.jain@ceew.in"]
[]
[null,null,"Copyright © 2016   2030 Water Resources Group & Council on Energy, Environment and Water (CEEW)\nOpen access. Some rights reserved. This database is licensed under the Creative Commons Attribution - Noncommercial 4.0 International (CC BY-NC 4.0) license. To view the full license, visit: www.creativecommons.org/licenses/by-nc/4.0/legalcode"]
[]
[null,"Suggested Citation","Sugam, Rudresh, Abhishek Jain, Kangkanika Neog. October 2016. Circular Economy Pathways for Wastewater Management in India - A Practitioners’ Guide. New Delhi: 2030 Water Resources Group/Council on Energy, Environment and Water."]

{"sheet":"Tool Guide","index":1,"n_rows":72,"n_cols":1,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["TOOL GUIDE"]
["MACROS need to be enabled in order to use this tool effectively."]
[]
["All the inputs required for the tool are need to be filled in this sheet. User should add/edit values in this sheet as per their discretion. These input value are reflected in specific sheet in pink color."]
[]
["1.      WW DEMAND AND COLLECTION: This sheet calculates the domestic,agricultural and industrial water demand"]
["User inputs reflected in pink cells "]
["·         Decadal growth in agriculture and industrial water demand; Current agriculture and industrial water demand. "]
["·         Population of previous decades"]
["·         Water supply in lpcd and % collection efficiency"]
["·         WW treatment capacity (if capacity is manually planned)"]
["Outputs populate in the blue cells as"]
["·         Agriculture and industrial water demands (for coming decades)"]
["·         Estimated population and corresponding water demand and WW generation for the next three decades"]
[]
["2.      Technologies - Input Cost: This sheet serves as a technology cost input sheet for various WW treatment technologies and collection network. "]
["Assumptions are given in purple cells."]
["User inputs reflected in pink cells "]
["·         INR to USD rate"]
["·         Cost of land ('000 INR/m2)"]
["·         CAPEX and OPEX (power, repairs, chemical, manpower)  investment in various technologies in INR (already entered from CPCB report, but can be changed)"]
["·         Land requirement in m2/MLD"]
["Outputs populate in the blue cells as"]
["·         Total cost of land per technology"]
["·         Total CAPEX (including cost of land)"]
["·         OPEX for first year of operation"]
[]
["3.      Other resources from wastewater: This sheet serves as cost input sheer for various technologies for energy (CHP unit for on-site electricity generation) and nutrient recovery (Phosphate and nitrogen recovery). "]
["Assumptions are given in purple cells."]
["User inputs reflected in pink cells "]
["·         CAPEX and OPEX (power, repairs, chemical, manpower) investment in various technologies in INR"]
["·         Land requirement in m2/MLD"]
["Outputs populate in the blue cells as"]
["·         Total cost of land per technology"]
["·         Total CAPEX + cost of land"]
["·         Total OPEX"]
[]
["4. WWTP - Capacity & Technology Selection: In this sheet, the user makes the decision for the capacity sizing of the treatment plant, as well as makes the choice of technologies to be used for treatment and recovery. User also need to input here the details of network infrastructure for pumping recyled water to point of sale"]
["User inputs reflected in pink cells "]
["·         WW treatment capacity as per? (select from drop down box)"]
["·         Appropriate technology for WW treatment"]
["·         If on-site electricity is to be generated, choose the option from dropdown list, else leave the cell empty"]
["·         If phosphorus is to be recovered, choose the option from dropdown list, else leave the cell empty"]
["·         Length of supply infrastructure"]
["Outputs populate in the blue cells as"]
["·         Total cost CAPEX (incl. cost of land) and OPEX for selected technologies"]
[]
["5. Revenue Earned: This sheet determines the total economic potential of recyled water, recovered energy and fertiliser."]
["User inputs reflected in pink cells "]
["·         Reclaimed water tariff for agriculture"]
["Outputs populate in the blue cells as"]
["·         Total water, energy and fertiliser selling potential"]
["·         Total revenue earned"]
[]
["6.      Economic Analysis-This is the main economic analysis sheet, where user provides all the major assumption with regards to economic analysis and the desired payback period of the intervention. Basis the user inputs, the tool (on pressing the 'Determine tariff' button) determines the tariff at which the recyled water could be sold to the industry."]
["User inputs reflected in pink cells "]
["·         Discount rate, rate of increase in repairs cost, chemical cost, manpower cost, agricultural water tariff, industrial water tariff, fertiliser tariff"]
["·         Variation in electricity tariff, cost of land, distance of industry from point of discharge, industrial water sale tariff"]
["·         Nominal rate of increase in electricity tariff"]
["·         Desired payback period"]
["·         Proportion of treated water for sale."]
["Outputs populate in the blue cells as"]
["·         Tariff for water resale to industries"]
["·         Net Present Value"]
[]
["7.      Summary sheet - provides a broad overview of the economic analysis with key figures"]
[]
["8.      ASSUMPTIONS FOR SENSITIVITY ANALYSIS - The sheet presents a reference case for sensitivity analysis. Depending upon the local context, the user may change the value of sensitivity scenarios (under the what -if manager in the Economic Analysis Sheet)"]
[]
["9.      SENSITVITY ANALYSIS OF TECHNOLOGIES AGAINST NPV(for reference case)"]
[]
["10.    SENSITVITY ANALYSIS OF TECHNOLOGIES AGAINST PAYBACK PERIOD (for reference case)"]

{"sheet":"Inputs","index":2,"n_rows":90,"n_cols":7,"rows_kept":90,"cut":false,"hidden":false,"merged":[[48,6,49,6],[48,2,48,5],[34,2,34,5],[48,0,49,0],[48,1,49,1],[0,0,0,1],[7,0,7,1],[28,0,28,1],[54,0,54,1],[71,0,71,1]]}
["1. General information"]
["a. INR to USD",67]
["b. Cost of Land (INR/m2)",4000]
["c. Power Tariff - INR/kWh",6]
["d. Fertiliser - MAP(Struvite) Price (INR per metric ton) ref. Feb 2012",20000]
["e. Tariff for reclaimed water for agriculture",0]
[]
["2. Water Demand Estimation"]
["Population (for domestic water demand estimtion)"]
["Year","POPULATION (million)"]
[1951,1.744]
[1961,2.6589999999999998]
[1971,4.0659999999999998]
[1981,6.22]
[1991,9.4209999999999994]
[2001,13.851000000000001]
[2011,16.753]
["Water Demand"]
["Agricultural",50]
["Industrial",20]
["Decadal growth in water demand"]
["Agricultural",0.1]
["Industrial",0.25]
["Water supply to domestic sector (in lpcd)",120]
["WW collection efficiency (in percent)",0.7]
[]
["Size of treatment plant in MLD (input only if you intend to manually plan the capacity and  not through population projections)",50]
[]
["3. Technologies - Input cost"]
["Collection network: Piping rates","'000 INR/m"]
["400  mm Diameter Pipe",3256]
["600  mm Diameter Pipe",6512]
["900 mm Diameter Pipe",19536]
[]
["Wastewater Treatment Technology","CAPEX/MLD*","Annula OPEX (INR/MLD)",null,null,null,"Land Requirement (m2/MLD)"]
[null,null,"Power Required","Repairs Cost","Chemical Cost","Manpower Cost"]
[null,"'000 INR","kWh/d/ MLD","'000 INR","'000 INR","'000 INR"]
["Waste Stabilization Pond (WSP)",2300,4.5,{"$f":"(1.11*100000)/1000","v":111.00000000000001},{"$f":"(0.6*100000)/1000","v":60},{"$f":"(0.51*100000)/1000","v":51},6000]
["WSP with Tertiary Treatment",6300,5.7,{"$f":"(1.76*100000)/1000","v":176},{"$f":"(7.2*100000)/1000","v":720},{"$f":"(0.6*100000)/1000","v":60},6100]
["Activated SludgeProcess (ASP)",6800,184.5,{"$f":"(1.5*100000)/1000","v":150},{"$f":"(0.85*100000)/1000","v":85},{"$f":"(0.67*100000)/1000","v":67},900]
["ASP with Tertiary Treatment",10800,185.7,{"$f":"(2.38*100000)/1000","v":238},{"$f":"(5.3*100000)/1000","v":530},{"$f":"(0.8*100000)/1000","v":80},1000]
["Sequencing Batch Reactor (SBR)",7500,152.5,{"$f":"(1.16*100000)/1000","v":115.99999999999999},{"$f":"(0.85*100000)/1000","v":85},{"$f":"(0.41*100000)/1000","v":41},450]
["SBR with Tertiary Treatment",11500,153.69999999999999,{"$f":"(1.84*100000)/1000","v":184},{"$f":"(5.3*100000)/1000","v":530},{"$f":"(0.5*100000)/1000","v":50},550]
["Moving Bed Biological Reactor (MBBR)",6800,222.5,{"$f":"(1.22*100000)/1000","v":122},{"$f":"(0.85*100000)/1000","v":85},{"$f":"(0.49*100000)/1000","v":49},450]
["MBBR with Tertiary Treatment",10800,223.7,{"$f":"(4.9*100000)/1000","v":490.00000000000006},{"$f":"(5.3*100000)/1000","v":530},{"$f":"(0.6*100000)/1000","v":60},550]
["Membrane Bioreactor (MBR)",30000,302.5,220,660,120,450]
["Upstream Anaerobic Sludge Blanket ",6800,125.7,{"$f":"(2.48*100000)/1000","v":248},{"$f":"(6.3*100000)/1000","v":630},{"$f":"(0.84*100000)/1000","v":84},1100]
[]
["Energy and Nutrient Recovery Technology","CAPEX/MLD","Annula OPEX (INR/MLD)",null,null,null,"Land Requirement (m2/MLD)"]
[null,null,"Power Cost","Repairs Cost","Chemical Cost","Manpower Cost"]
[null,"' 000 INR","' 000 INR","' 000 INR","' 000 INR","' 000 INR"]
["Biogas to electricity unit",125,0,6.25,0,0,5]
["Struvite Recovery",281.77499999999998,7.5,7.5,30,7.5,5]
[]
["4. WWTP-Capacity & Technology Selection"]
[null,"Select from drop-down list"]
["WW treatment capacity as per ","Manually planned"]
["Technology for WW treatment","ASP with Tertiary Treatment"]
["For on-site power generation (leave blank if not planned)","Biogas to electricity unit"]
["For Phosphate Recovery (leave blank if not planned)"]
["Length of supply infrastructure"]
["Industrial"]
["400 mm Dia Pipe (m) ",0]
["600 mm Dia Pipe (m) ",500]
["900 mm Dia Pipe (m) ",700]
["Agricultural"]
["400 mm Dia Pipe (m) ",600]
["600 mm Dia Pipe (m) ",700]
["900 mm Dia Pipe (m) ",1200]
[]
[]
["5. Other Variables"]
[null,"in percentage"]
["Discount rate",0.1]
["Rate of increase of repair costs",0.05]
["Rate of increase of chemical cost",0.05]
["Rate of increase of manpower cost",0.1]
["Rate of increase of agricultural water tariff",0.04]
["Rate of increase of industrial water tariff",0.05]
["Rate of increase of fertiliser tariff",0.05]
[]
["Following are the variables (also) used for sensitivity anaysis (please refer scenario manager (under What-If analysis) in case you want to change the values"]
["Variation in the electricity tariff",1]
["Variation in the cost of land",1]
["Variation in distance of industry from point of STP discharge",1]
["Nominal rate of increase in electricity Tariff",0.08]
["Variation in industrial water sale tariff",1]
[]
["Enter your desired payback period (years)",10]
["Enter the proportion of treated water for sale",0.4]

{"sheet":"WW Demand and Collection","index":3,"n_rows":57,"n_cols":9,"rows_kept":57,"cut":false,"hidden":false,"merged":[[21,0,21,2],[36,0,36,4],[0,0,0,8],[1,0,1,8],[29,0,29,4],[3,0,3,3],[16,0,16,2],[15,0,15,3],[5,0,5,3],[7,0,7,2],[6,0,6,2],[27,0,27,2],[26,0,26,2],[25,0,25,2],[24,0,24,2],[23,0,23,2],[22,0,22,2],[41,0,41,3],[40,0,40,3],[39,0,39,3],[38,0,38,3],[37,0,37,3],[15,5,15,8],[18,5,18,7],[17,5,17,7],[16,5,16,7],[20,0,20,2],[19,0,19,2],[18,0,18,2],[17,0,17,2]]}
["Input: Decadal growth in agriculture and industrial water demand, present agriculture and industrial water demand, population of previous decades, water supply in lpcd, % collection efficiency, WW treatment capacity as per manual planning"]
["Output: Agriculture and industrial water demand projections, population projections"]
[]
["WATER DEMAND"]
[]
["Decadal growth in water demand"]
["Agricultural",null,null,{"$f":"Inputs!B22","v":0.1}]
["Industrial",null,null,{"$f":"Inputs!B23","v":0.25}]
[]
["Water Demand in MLD","Domestic","Agricultural","Industrial"]
[2011,{"$f":"C32","v":2010.3600000000001},{"$f":"Inputs!B19","v":50},{"$f":"Inputs!B20","v":20}]
[2021,{"$f":"C33","v":2576.6340892740004},{"$f":"C11*(1+$D$7)","v":55.000000000000007},{"$f":"D11*(1+$D$8)","v":25}]
[2031,3222.450215019011,{"$f":"C12*(1+$D$7)","v":60.500000000000014},{"$f":"D12*(1+$D$8)","v":31.25}]
[2041,4134.3148907061714,{"$f":"C13*(1+$D$7)","v":66.550000000000026},{"$f":"D13*(1+$D$8)","v":39.0625}]
[]
["POPULATION (for estimation of domestic water demand)",null,null,null,null,"Domestic water supply and WW generation (assumptions)"]
["YEAR",null,null,"POPULATION (million)",null,"Water Supply (in lpcd)",null,null,{"$f":"Inputs!B24","v":120}]
[1951,null,null,{"$f":"Inputs!B11","v":1.744},null,"WW Generation (as % of water supply)",null,null,0.8]
[1961,null,null,{"$f":"Inputs!B12","v":2.6589999999999998},null,"Collection efficiency in %",null,null,{"$f":"Inputs!B25","v":0.7}]
[1971,null,null,{"$f":"Inputs!B13","v":4.0659999999999998}]
[1981,null,null,{"$f":"Inputs!B14","v":6.22}]
[1991,null,null,{"$f":"Inputs!B15","v":9.4209999999999994}]
[2001,null,null,{"$f":"Inputs!B16","v":13.851000000000001}]
[2011,null,null,{"$f":"Inputs!B17","v":16.753}]
[]
[2021,null,null,{"$f":"AVERAGE(A55:C55)","v":21.471950743950003}]
[2031,null,null,{"$f":"AVERAGE(A56:C56)","v":26.85375179182509}]
[2041,null,null,{"$f":"AVERAGE(A57:C57)","v":34.452624089218091}]
[]
["Domestic WW collection (MLD)"]
[null,"Population","Water Supply ","WW Generation ","Collected WW"]
[2011,{"$f":"'WW Demand and Collection'!D24","v":16.753},{"$f":"I17*B32","v":2010.3600000000001},{"$f":"$I$18*C32","v":1608.2880000000002},{"$f":"($I$19)*D32","v":1125.8016}]
[2021,{"$f":"'WW Demand and Collection'!D26","v":21.471950743950003},{"$f":"I17*B33","v":2576.6340892740004},{"$f":"$I$18*C33","v":2061.3072714192003},{"$f":"($I$19)*D33","v":1442.9150899934402}]
[2031,{"$f":"'WW Demand and Collection'!D27","v":26.85375179182509},{"$f":"I17*B34","v":3222.450215019011},{"$f":"$I$18*C34","v":2577.9601720152091},{"$f":"($I$19)*D34","v":1804.5721204106462}]
[2041,{"$f":"'WW Demand and Collection'!D28","v":34.452624089218091},{"$f":"I17*B35","v":4134.3148907061714},{"$f":"$I$18*C35","v":3307.4519125649372},{"$f":"($I$19)*D35","v":2315.2163387954561}]
[]
["WW treatment capacity in MLD as per "]
["Population: 2011",null,null,null,{"$f":"E32","v":1125.8016}]
["Population: 2021",null,null,null,{"$f":"E33","v":1442.9150899934402}]
["Population: 2031",null,null,null,{"$f":"E34","v":1804.5721204106462}]
["Population: 2041",null,null,null,{"$f":"E35","v":2315.2163387954561}]
["Manually planned",null,null,null,{"$f":"Inputs!B27","v":50}]
[]
["Annex - Calculations for population forecasting"]
["INCREMENT","GEOMETRICAL INCREASE RATE OF GROWTH","INCREMENTAL INCREASE"]
[]
[{"$f":"D19-D18","v":0.91499999999999981},{"$f":"A47/D18","v":0.52465596330275222}]
[1.407,0.5291462955998496,{"$f":"A48-A47","v":0.49200000000000021}]
[2.1539999999999999,0.52975897688145601,{"$f":"A49-A48","v":0.74699999999999989}]
[3.2009999999999996,0.51463022508038581,1.0469999999999997]
[4.4300000000000015,0.47022609064855131,1.2290000000000019]
[2.9019999999999992,0.20951555844343361,-1.5280000000000022]
[{"$f":"AVERAGE(A47:A52)","v":2.5015000000000001},{"$f":"AVERAGE(B47:B52)","v":0.46298885165940468},{"$f":"AVERAGE(C48:C52)","v":0.39739999999999986}]
["Arithmetical Increase","Geometrical Increase","Incremental Increase"]
[{"$f":"D24+A53","v":19.2545},{"$f":"D24*((1+B53)^1)","v":24.509452231850009},{"$f":"D24+(1+A53)+((1*(1+1))/2)*C53","v":20.651900000000001}]
[{"$f":"D24+(A53*2)","v":21.756},{"$f":"D24*((1+B53)^2)","v":35.857055375475277},{"$f":"D24+(2*A53)+((2*(2+1))/2)*C53","v":22.9482}]
[{"$f":"D24+(A53*3)","v":24.2575},{"$f":"D24*((1+B53)^3)","v":52.458472267654265},{"$f":"D24+(3*A53)+((3*(3+1))/2)*C53","v":26.6419}]

{"sheet":"Technologies - Input cost","index":4,"n_rows":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,0,35,15],[0,0,0,8],[1,0,1,8],[19,16,19,22],[3,0,3,1],[20,1,20,2],[20,4,20,5],[19,4,19,11],[20,6,20,7],[20,8,20,9],[20,10,20,11],[19,1,19,2],[9,0,9,2]]}
["Input: INR to USD, cost of land per unit area, CAPEX-OPEX (power, repairs, chemical, manpower) of technologies, price of land and Requirement of land"]
["Output: Total cost of land, Total CAPEX + Cost of land, Total OPEX"]
[]
["ASSUMPTIONS"]
["Recovery after Secondary STP",0.8]
["Recovery after Tertiary (Non-R.O)",0.8]
[]
["INR to USD",{"$f":"Inputs!B2","v":67}]
[]
["Collection Network - Piping rates"]
[null,"'000 INR/m","'000 USD/m"]
["400  mm Diameter Pipe",{"$f":"Inputs!B31","v":3256},{"$f":"B12/B8","v":48.597014925373138}]
["600  mm Diameter Pipe",{"$f":"Inputs!B32","v":6512},{"$f":"B13/B8","v":97.194029850746276}]
["900 mm Diameter Pipe",{"$f":"Inputs!B33","v":19536},{"$f":"B14/B8","v":291.58208955223881}]
[]
["Cost of Land (INR/m2)",{"$f":"Inputs!B3","v":4000}]
[]
["Power Tariff - INR/kWh",{"$f":"Inputs!B4","v":6}]
[]
["Technology","CAPEX/MLD*",null,null,"Annual OPEX/MLD",null,null,null,null,null,null,null,"Land Requirement (m2/MLD)","Total Cost of Land","Total CAPEX (inc. cost of land)","Annual OPEX","Output Water Quality"]
[null,null,null,"Power Required","Power Cost",null,"Repairs Cost",null,"Chemical Cost",null,"Manpower Cost",null,null,"million INR/MLD","million INR/MLD","million INR/MLD","BOD (mg/L)","SS (mg/L)","Faecal Coliform Removal (log unit)","T - N Removal Efficiency (%)","Effluent NH3N (mg/L)","Effluent TP (mg/L)","Effluent Total Coliforms, (MPN/100mL)"]
[null,"'000 INR","'000 USD","kWh/d/ MLD","'000 INR","'000 USD","'000 INR","'000 USD","'000 INR","'000 USD","'000 INR","'000 USD"]
["Waste Stabilization Pond (WSP)",{"$f":"Inputs!B38","v":2300},{"$f":"B23/B8","v":34.328358208955223},{"$f":"Inputs!C38","v":4.5},{"$f":"(D23*$B$18*365*'Economic Analysis'!$B$14)/1000","v":9.8550000000000004},{"$f":"E23/B8","v":0.14708955223880599},{"$f":"Inputs!D38","v":111.00000000000001},{"$f":"G23/B8","v":1.6567164179104479},{"$f":"Inputs!E38","v":60},{"$f":"I23/B8","v":0.89552238805970152},{"$f":"Inputs!F38","v":51},{"$f":"K23/B8","v":0.76119402985074625},{"$f":"Inputs!G38","v":6000},{"$f":"(M23*$B$16*'Economic Analysis'!$B$15)/1000000","v":24},{"$f":"B23/1000+N23","v":26.3},{"$f":"(E23+G23+I23+K23)/1000","v":0.23185500000000001},"<40","<100","Upto 2<3","10 - 20"]
["WSP with Tertiary Treatment",{"$f":"Inputs!B39","v":6300},{"$f":"B24/B8","v":94.02985074626865},{"$f":"Inputs!C39","v":5.7},{"$f":"(D24*$B$18*365*'Economic Analysis'!$B$14)/1000","v":12.483000000000002},{"$f":"E24/B8","v":0.18631343283582094},{"$f":"Inputs!D39","v":176},{"$f":"G24/B8","v":2.6268656716417911},{"$f":"Inputs!E39","v":720},{"$f":"I24/B8","v":10.746268656716419},{"$f":"Inputs!F39","v":60},{"$f":"K24/B8","v":0.89552238805970152},{"$f":"Inputs!G39","v":6100},{"$f":"(M24*$B$16*'Economic Analysis'!$B$15)/1000000","v":24.4},{"$f":"B24/1000+N24","v":30.7},{"$f":"(E24+G24+I24+K24)/1000","v":0.96848299999999998},"<10","<5",null,null,"<1","<0.5",10]
["Activated SludgeProcess (ASP)",{"$f":"Inputs!B40","v":6800},{"$f":"B25/B8","v":101.49253731343283},{"$f":"Inputs!C40","v":184.5},{"$f":"(D25*$B$18*365*'Economic Analysis'!$B$14)/1000","v":404.05500000000001},{"$f":"E25/B8","v":6.0306716417910451},{"$f":"Inputs!D40","v":150},{"$f":"G25/B8","v":2.2388059701492535},{"$f":"Inputs!E40","v":85},{"$f":"I25/B8","v":1.2686567164179106},{"$f":"Inputs!F40","v":67},{"$f":"K25/B8","v":1},{"$f":"Inputs!G40","v":900},{"$f":"(M25*$B$16*'Economic Analysis'!$B$15)/1000000","v":3.6},10.4,0.7060550000000001,"<20","<30","Upto 2<3","10 - 20"]
["ASP with Tertiary Treatment",{"$f":"Inputs!B41","v":10800},{"$f":"B26/B8","v":161.19402985074626},{"$f":"Inputs!C41","v":185.7},{"$f":"(D26*$B$18*365*'Economic Analysis'!$B$14)/1000","v":406.68299999999994},{"$f":"E26/B8","v":6.0698955223880589},{"$f":"Inputs!D41","v":238},{"$f":"G26/B8","v":3.5522388059701493},{"$f":"Inputs!E41","v":530},{"$f":"I26/B8","v":7.91044776119403},{"$f":"Inputs!F41","v":80},{"$f":"K26/B8","v":1.1940298507462686},{"$f":"Inputs!G41","v":1000},{"$f":"(M26*$B$16*'Economic Analysis'!$B$15)/1000000","v":4},14.8,1.254683,"<10","<5",null,null,"<1","<0.5",10]
["Sequencing Batch Reactor (SBR)",{"$f":"Inputs!B42","v":7500},{"$f":"B27/B8","v":111.94029850746269},{"$f":"Inputs!C42","v":152.5},{"$f":"(D27*$B$18*365*'Economic Analysis'!$B$14)/1000","v":333.97500000000002},{"$f":"E27/B8","v":4.9847014925373134},{"$f":"Inputs!D42","v":115.99999999999999},{"$f":"G27/B8","v":1.7313432835820894},{"$f":"Inputs!E42","v":85},{"$f":"I27/B8","v":1.2686567164179106},{"$f":"Inputs!F42","v":41},{"$f":"K27/B8","v":0.61194029850746268},{"$f":"Inputs!G42","v":450},{"$f":"(M27*$B$16*'Economic Analysis'!$B$15)/1000000","v":1.8},9.3000000000000007,0.57597500000000001,"<10","<10","Upto 3<4","70 - 80"]
["SBR with Tertiary Treatment",{"$f":"Inputs!B43","v":11500},{"$f":"B28/B8","v":171.64179104477611},{"$f":"Inputs!C43","v":153.69999999999999},{"$f":"(D28*$B$18*365*'Economic Analysis'!$B$14)/1000","v":336.60300000000001},{"$f":"E28/B8","v":5.0239253731343281},{"$f":"Inputs!D43","v":184},{"$f":"G28/B8","v":2.7462686567164178},{"$f":"Inputs!E43","v":530},{"$f":"I28/B8","v":7.91044776119403},{"$f":"Inputs!F43","v":50},{"$f":"K28/B8","v":0.74626865671641796},{"$f":"Inputs!G43","v":550},{"$f":"(M28*$B$16*'Economic Analysis'!$B$15)/1000000","v":2.2000000000000002},13.7,1.100603,"<10","<5",null,null,"<1","<0.5",10]
["Moving Bed Biological Reactor (MBBR)",{"$f":"Inputs!B44","v":6800},{"$f":"B29/B8","v":101.49253731343283},{"$f":"Inputs!C44","v":222.5},{"$f":"(D29*$B$18*365*'Economic Analysis'!$B$14)/1000","v":487.27499999999998},{"$f":"E29/B8","v":7.27276119402985},{"$f":"Inputs!D44","v":122},{"$f":"G29/B8","v":1.8208955223880596},{"$f":"Inputs!E44","v":85},{"$f":"I29/B8","v":1.2686567164179106},{"$f":"Inputs!F44","v":49},{"$f":"K29/B8","v":0.73134328358208955},{"$f":"Inputs!G44","v":450},{"$f":"(M29*$B$16*'Economic Analysis'!$B$15)/1000000","v":1.8},8.6,0.74327500000000002,"<30","<30","Upto 2<3","10 - 20"]
["MBBR with Tertiary Treatment",{"$f":"Inputs!B45","v":10800},{"$f":"B30/B8","v":161.19402985074626},{"$f":"Inputs!C45","v":223.7},{"$f":"(D30*$B$18*365*'Economic Analysis'!$B$14)/1000","v":489.90299999999996},{"$f":"E30/B8","v":7.3119850746268655},{"$f":"Inputs!D45","v":490.00000000000006},{"$f":"G30/B8","v":7.3134328358208966},{"$f":"Inputs!E45","v":530},{"$f":"I30/B8","v":7.91044776119403},{"$f":"Inputs!F45","v":60},{"$f":"K30/B8","v":0.89552238805970152},{"$f":"Inputs!G45","v":550},{"$f":"(M30*$B$16*'Economic Analysis'!$B$15)/1000000","v":2.2000000000000002},13,1.569903,"<10","<5",null,null,"<1","<0.5",10]
["Membrane Bioreactor (MBR)",{"$f":"Inputs!B46","v":30000},{"$f":"B31/B8","v":447.76119402985074},{"$f":"Inputs!C46","v":302.5},{"$f":"(D31*$B$18*365*'Economic Analysis'!$B$14)/1000","v":662.47500000000002},{"$f":"E27/B8","v":4.9847014925373134},{"$f":"Inputs!D46","v":220},{"$f":"G31/B8","v":3.283582089552239},{"$f":"Inputs!E46","v":660},{"$f":"I31/B8","v":9.8507462686567155},{"$f":"Inputs!F46","v":120},{"$f":"K31/B8","v":1.791044776119403},{"$f":"Inputs!G46","v":450},{"$f":"(M31*$B$16*'Economic Analysis'!$B$15)/1000000","v":1.8},31.8,1.6624749999999999,"<5","<5","Upto 5<6","70 - 80"]
["Upstream Anaerobic Sludge Blanket ",{"$f":"Inputs!B47","v":6800},{"$f":"B32/'Technologies - Input cost'!B8","v":101.49253731343283},{"$f":"Inputs!C47","v":125.7},{"$f":"(D32*$B$18*365*'Economic Analysis'!$B$14)/1000","v":275.28300000000002},{"$f":"E32/$B8","v":4.108701492537314},{"$f":"Inputs!D47","v":248},{"$f":"G32/B8","v":3.7014925373134329},{"$f":"Inputs!E47","v":630},{"$f":"I32/B8","v":9.4029850746268657},{"$f":"Inputs!F47","v":84},{"$f":"K32/B8","v":1.2537313432835822},{"$f":"Inputs!G47","v":1100},{"$f":"(M32*$B$16*'Economic Analysis'!$B$15)/1000000","v":4.4000000000000004},11.2,1.2372829999999999]
[]
["*It should be noted that the reference values for CAPEX are from CPCB. Our interactions with practitioners suggest that these are conservative numbers and actual numbers could be higher. However, given no other publicly available information, we have used these numbers as reference. Practitioners are urged to input more adequate CAPEX number as per their experience or in discussion with technology providers. The CAPEX per MLD also strongly depends on the total capacity of the plant. The smaller the plant, the higher is the CAPEX. For instance, for a plant smaller than 10 MLD, the cost provided in the tool might increase by 100%."]

{"sheet":"Other resources from WW","index":5,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,2,11,10],[4,6,4,7],[4,8,4,9],[4,10,4,11],[4,4,4,5],[3,2,4,3],[3,12,4,12],[3,4,3,11],[0,0,0,11],[9,1,9,10],[10,2,10,10],[1,0,1,4],[3,1,4,1]]}
["Input: CAPEX-OPEX (power, repairs, chemical, manpower) of technologies, price of land and Requirement of land"]
["Output: Cost of land, Total cost of technologies"]
[]
[null,"Technology","CAPEX/MLD",null,"Annula OPEX (INR/MLD)",null,null,null,null,null,null,null,"Land Requirement (m2/MLD)","Total Cost of Land","Total CAPEX (incl. cost of Land)","Total OPEX"]
[null,null,null,null,"Power Cost",null,"Repairs Cost",null,"Chemical Cost",null,"Manpower Cost",null,null,"million INR/MLD","million INR/MLD","million INR/MLD"]
[null,null,"' 000 INR","' 000 USD","' 000 INR","' 000 USD","' 000 INR","' 000 USD","' 000 INR","' 000 USD","' 000 INR","' 000 USD"]
["For On-site Power generation","Biogas to electricity unit",{"$f":"Inputs!B52","v":125},{"$f":"C7/'Technologies - Input cost'!B8","v":1.8656716417910448},{"$f":"Inputs!C52","v":0},{"$f":"E7/'Technologies - Input cost'!B8","v":0},{"$f":"Inputs!D52","v":6.25},{"$f":"G7/'Technologies - Input cost'!$B$8","v":9.3283582089552244E-2},{"$f":"Inputs!E52","v":0},{"$f":"I7/'Technologies - Input cost'!B8","v":0},{"$f":"Inputs!F52","v":0},{"$f":"K7/'Technologies - Input cost'!B8","v":0},{"$f":"Inputs!G52","v":5},{"$f":"M7*'Technologies - Input cost'!$B$16/1000000","v":0.02},{"$f":"C7/1000+N7","v":0.14499999999999999},{"$f":"(E7+G7+I7+K7)/1000","v":6.2500000000000003E-3}]
["For Phosphate Recovery ","Struvite Recovery",{"$f":"Inputs!B53","v":281.77499999999998},{"$f":"C8/'Technologies - Input cost'!B8","v":4.205597014925373},{"$f":"Inputs!C53","v":7.5},{"$f":"E8/'Technologies - Input cost'!B8","v":0.11194029850746269},{"$f":"Inputs!D53","v":7.5},{"$f":"G8/'Technologies - Input cost'!B8","v":0.11194029850746269},{"$f":"Inputs!E53","v":30},{"$f":"I8/'Technologies - Input cost'!B8","v":0.44776119402985076},{"$f":"Inputs!F53","v":7.5},{"$f":"K8/'Technologies - Input cost'!B8","v":0.11194029850746269},{"$f":"Inputs!G53","v":5},{"$f":"M8*'Technologies - Input cost'!$B$16/1000000","v":0.02},{"$f":"C8/1000+N8","v":0.30177500000000002},{"$f":"(E8+G8+I8+K8)/1000","v":5.2499999999999998E-2}]
[]
[null,"Sources:"]
[null,"CHP","Opportunities for and Benefits of Combined Heat and Power at Wastewater Treatment Facilities, USEPA, 2006"]
[null,"Phophorus","http://www.ncbi.nlm.nih.gov/pmc/articles/PMC3357736/"]

{"sheet":"WWTP-Capacity & Tech. Selection","index":6,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,24,2],[0,0,0,9],[12,4,23,7],[6,0,6,7],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,17,0],[18,0,23,0],[12,1,14,1],[15,1,17,1],[18,1,20,1],[21,1,23,1],[1,0,1,9],[7,0,7,1]]}
["Input: WW treatment capacity as per (select from drop down list), Distance to point of sale in metres, Technology for Primary and Secondary treatment (select from dropdown list), Technology for on-site CHP generation for N and P recovery, Length of supply infrastructure (for both agriculture and industrial)"]
["Output: Total CAPEX + Cost of land, Total Power Cost, Total Repairs Cost, Total Chemical Cost, Total Manpower Cost"]
[]
[null,null,"in MLD"]
["WW treatment capacity as per ",{"$f":"Inputs!B57","v":"Manually planned"},{"$f":"IFERROR(VLOOKUP(B5,'WW Demand and Collection'!A38:E42,5,FALSE),0)","v":50}]
[]
["Cost Incurred (million INR)"]
[null,null,"Select from drop-down list","CAPEX (inc. cost of land)","Power Cost","Repairs cost","Chemical Cost","Manpower Cost"]
[null,null,null,"million INR","million INR","million INR","million INR","million INR"]
["Technology for WW treatment",null,{"$f":"Inputs!B58","v":"ASP with Tertiary Treatment"},{"$f":"(IFERROR(VLOOKUP(C10,'Technologies - Input cost'!A23:P38,15,FALSE),0))*C5","v":740},{"$f":"(IFERROR(VLOOKUP(C10,'Technologies - Input cost'!A23:P38,5,FALSE),0))*C5/1000","v":20.334149999999998},{"$f":"(IFERROR(VLOOKUP(C10,'Technologies - Input cost'!A23:P38,7,FALSE),0))*C5/1000","v":11.9},{"$f":"(IFERROR(VLOOKUP(C10,'Technologies - Input cost'!A23:P38,9,FALSE),0))*C5/1000","v":26.5},{"$f":"(IFERROR(VLOOKUP(C10,'Technologies - Input cost'!A23:P38,11,FALSE),0))*C5/1000","v":4}]
["For on-site power generation",null,{"$f":"Inputs!B59","v":"Biogas to electricity unit"},{"$f":"IFERROR(VLOOKUP(C11,'Other resources from WW'!B7:P7,14,FALSE),0)*C5","v":7.2499999999999991},{"$f":"IFERROR(VLOOKUP(C11,'Other resources from WW'!B7:P7,4,FALSE),0)*C5/1000","v":0},{"$f":"IFERROR(VLOOKUP(C11,'Other resources from WW'!B7:P7,6,FALSE),0)*C5/1000","v":0.3125},{"$f":"IFERROR(VLOOKUP(C11,'Other resources from WW'!B7:P7,8,FALSE),0)*C5/1000","v":0},{"$f":"IFERROR(VLOOKUP(C11,'Other resources from WW'!B7:P7,10,FALSE),0)*C5/1000","v":0}]
["For Phosphate Recovery",null,{"$f":"Inputs!B60","v":0},{"$f":"IFERROR(VLOOKUP(C12,'Other resources from WW'!B8:P8,14,FALSE),0)*C5","v":0},{"$f":"IFERROR(VLOOKUP(C12,'Other resources from WW'!B8:P8,4,FALSE),0)*C5/1000","v":0},{"$f":"IFERROR(VLOOKUP(C12,'Other resources from WW'!B8:P8,6,FALSE),0)*C5/1000","v":0},{"$f":"IFERROR(VLOOKUP(C12,'Other resources from WW'!B8:P8,8,FALSE),0)*C5/1000","v":0},{"$f":"IFERROR(VLOOKUP(C12,'Other resources from WW'!B8:P8,10,FALSE),0)*C5/1000","v":0}]
["Length of Supply Infrastructure","Industrial","400 mm Dia Pipe (m) ",{"$f":"Inputs!B63","v":0}]
[null,null,"600 mm Dia Pipe (m) ",{"$f":"Inputs!B64","v":500}]
[null,null,"900 mm Dia Pipe (m) ",{"$f":"Inputs!B65","v":700}]
[null,"Agricultural","400 mm Dia Pipe (m) ",{"$f":"Inputs!B67","v":600}]
[null,null,"600 mm Dia Pipe (m) ",{"$f":"Inputs!B68","v":700}]
[null,null,"900 mm Dia Pipe (m) ",{"$f":"Inputs!B69","v":1200}]
["Cost of Supply Infrastructure","Industrial","400 mm Dia Pipe ('000 INR)",{"$f":"'Technologies - Input cost'!B12*D13*'Economic Analysis'!B16/1000000","v":0}]
[null,null,"600  mm Dia Pipe ('000 INR)",{"$f":"'Technologies - Input cost'!B13*D14*'Economic Analysis'!B16/1000000","v":3.2559999999999998}]
[null,null,"900 mm Dia Pipe ('000 INR)",{"$f":"'Technologies - Input cost'!B14*D15*'Economic Analysis'!B16/1000000","v":13.6752}]
[null,"Agricultural","400 mm Dia Pipe ('000 INR)",{"$f":"'Technologies - Input cost'!B12*D16/1000000","v":1.9536}]
[null,null,"600 mm  Dia Pipe ('000 INR)",{"$f":"'Technologies - Input cost'!B13*D17/1000000","v":4.5583999999999998}]
[null,null,"900 mm Dia Pipe ('000 INR)",{"$f":"'Technologies - Input cost'!B14*D18/1000000","v":23.443200000000001}]
["Total Cost Incurred",null,null,{"$f":"SUM(D10:D12,D19:D24)","v":794.13640000000009},{"$f":"(E10+E11+E12)","v":20.334149999999998},{"$f":"(F10+F11+F12)","v":12.2125},{"$f":"(G10+G11+G12)","v":26.5},{"$f":"(H10+H11+H12)","v":4}]

{"sheet":"Revenue Earned","index":7,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[24,0,24,2],[0,0,0,5],[1,0,1,5],[3,0,3,4]]}
["Input: Reclaimed water tariff from agriculture"]
["Output: Water, electricity and fertiliser selling potential"]
[]
["ASSUMPTIONS"]
[1,"MLD of wastewater","equals",100,"m3 of biogas generated","REF: Biogas Production in Municipal Wastewater Treatment Plants – Current Status in EU with a Focus on the Slovak Republic\nhttp://www.academia.edu/4921725/Resource_Recovery_from_Sewage_Treatment_Plants"]
[1,"m3 of biogas generated","equals",1.6,"kWh of electricity","REF: Jangid and Gupta, 2014"]
[1,"litre of wastewater","equals",10,"mg of MAP (Struvite)"]
[1,"mg","equals",{"$f":"10^-9","v":1.0000000000000001E-9},"metric ton"]
[]
["For Electricity Generation","Amount of electricity that can be produced",{"$f":"'WWTP-Capacity & Tech. Selection'!C5*D5*D6","v":8000},"kWh"]
[null,"Capacity utilisation of power generation unit",0.9," "]
[null,"Capacity of power generation unit",{"$f":"C10/24/C11","v":370.37037037037032},"kW"]
[]
["Commodity Prices - Electricity & Fetiliser","Electricity - INR per kWh (energy generated from biogas)","Fertiliser - INR per metric ton\nMAP(Struvite) for Feb 2012","Ref: Ministry of Chemicals & Fertilisers, Dept. of Fertilisers, Govt. of India "]
["Price",{"$f":"'Technologies - Input cost'!B18","v":6},{"$f":"Inputs!B5","v":20000}]
[]
["Tariff for recycled water","INR/kl","USD/kl"]
["Reclaimed (Agricultural)",{"$f":"Inputs!B6","v":0},{"$f":"B18/'Technologies - Input cost'!$B$8","v":0}]
["Reclaimed (Industrial)",30.780919162927063,{"$f":"B19/'Technologies - Input cost'!$B$8","v":0.45941670392428452}]
[]
["Total Treated wastewater generated (MLD)",{"$f":"'WWTP-Capacity & Tech. Selection'!C5*IF(C21=TRUE,80%,64%)","v":32},{"$f":"OR('WWTP-Capacity & Tech. Selection'!C10='Technologies - Input cost'!A23,'WWTP-Capacity & Tech. Selection'!C10='Technologies - Input cost'!A25,'WWTP-Capacity & Tech. Selection'!C10='Technologies - Input cost'!A27,'WWTP-Capacity & Tech. Selection'!C10='Technologies - Input cost'!A29)","v":false}]
["Water to be supplied for agriculture (MLD)",{"$f":"IF(B21-B23>'WW Demand and Collection'!C11,'WW Demand and Collection'!C11,B21-B23)","v":19.2},"*capped at the maximum demand (from the demand sheet)"]
["Water to be supplied for Industries (MLD)",{"$f":"IF(B21*'Economic Analysis'!$B$22>'WW Demand and Collection'!D11,'WW Demand and Collection'!D11,B21*'Economic Analysis'!$B$22)","v":12.8},"*capped at the maximum demand (from the demand sheet)"]
[]
["Annual Revenue Generated (current year)"]
[null,null,"Total Revenue ('000 INR)"]
["Annual Water Selling Potential: Agriculture","Reclaimed (Agricultural)",{"$f":"(IF('WWTP-Capacity & Tech. Selection'!D10=0,0,B18)*IF(B22>'WW Demand and Collection'!C11,'WW Demand and Collection'!D11,B22)*365/1000)","v":0}]
["Annual Water Selling Potential: Industry","Reclaimed (Industrial)",{"$f":"(IF('WWTP-Capacity & Tech. Selection'!D10=0,0,B19)*B23*365/1000)","v":143.80845432919523}]
["Annual Electricity Selling Potential",null,{"$f":"(IF('WWTP-Capacity & Tech. Selection'!D11=0,0,C10*B15*365)*'Economic Analysis'!$B$14)/1000000","v":17.52}]
["Annual Fertiliser Selling Potential",null,{"$f":"(IF('WWTP-Capacity & Tech. Selection'!D12=0,0,('WWTP-Capacity & Tech. Selection'!C5*D7*D8*C15*365)))","v":0}]
["Annual Revenue",null,{"$f":"SUM(C27:C30)","v":161.32845432919524}]
[]
["Note:"]
["1. The annual health cost per child in the untreated WW irrigated environment is around INR 4000/annum, which is 73% higher than the annual health cost per child in freshwater irrigated area (Grangier et al. 2012)"]
["2. As per a 2015 UNEP study, establishment of a 25 year lifespan WW treatment plant leads to a total health benefits of around INR 5 million and the total economic value of environmental benefits is around INR 80 million."]

{"sheet":"Economic Analysis","index":8,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,0,1,6],[46,2,46,15],[0,0,0,8],[28,0,28,15]]}
["Input: Discount rate, rate of increase in repairs cost, chemical cost, manpower cost, agricultural water tariff, industrial water tariff, fertiliser tariff; Variation in electricity tariff, cost of land, distance of industry from point of discharge, industrial water sale tariff; Nominal rate of increase in electricity tariff; Desired payback period; Proportion of treated water for sale."]
["Output: Tariff for water resale to industries, NPV"]
[]
["Variable","in percentage"]
["Discount rate",{"$f":"Inputs!B74","v":0.1}]
["Rate of increase of repair costs",{"$f":"Inputs!B75","v":0.05}]
["Rate of increase of chemical cost",{"$f":"Inputs!B76","v":0.05}]
["Rate of increase of manpower cost",{"$f":"Inputs!B77","v":0.1},null,null," "]
["Rate of increase of agricultural water tariff",{"$f":"Inputs!B78","v":0.04}]
["Rate of increase of industrial water tariff",{"$f":"Inputs!B79","v":0.05}]
["Rate of increase of fertiliser tariff",{"$f":"Inputs!B80","v":0.05}]
[]
["Following are the variables (also) used for sensitivity anaysis (please refer scenario manager (under What-If analysis) in case you want to change the values"]
["Variation in the electricity tariff",1]
["Variation in the cost of land",1]
["Variation in distance of industry from point of STP discharge",1]
["Nominal rate of increase in electricity Tariff",0.08]
["Variation in industrial water sale tariff",1]
[]
["Enter your Desired Payback period (years)",{"$f":"Inputs!B89","v":10}]
[]
["Enter the proportion of treated water for sale",{"$f":"Inputs!B90","v":0.4},{"$f":"'Revenue Earned'!B23","v":12.8},"MLD"]
["Cost",{"$f":"SUM(OFFSET($B$39,0,0,1,$B$20))","v":1338.4374983984505}]
["Revenue",{"$f":"SUM(OFFSET($B$45,0,0,1,$B$20))","v":1338.4374983984501}]
[null,{"$f":"B23-B24","v":0}]
[]
[null,{"$f":"'Revenue Earned'!B19","v":30.780919162927063},"INR/kl"]
[]
["Detailed Cash Flows (in million INR)"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15"]
[null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14]
["Capital outlay",{"$f":"'WWTP-Capacity & Tech. Selection'!D25","v":794.13640000000009},0,0,0,0,0,0,0,0,0]
["Energy cost",{"$f":"'WWTP-Capacity & Tech. Selection'!E25","v":20.334149999999998},{"$f":"B33*(1+$B17)","v":21.960881999999998},23.717752560000001,25.615172764800004,27.664386585984005,29.877537512862727,32.267740513891745,34.849159755003086,37.637092535403333,40.648059938235605,43.899904733294456,47.411897111958012,51.204848880914653,55.301236791387829,59.725335734698859]
["Repair Cost",{"$f":"'WWTP-Capacity & Tech. Selection'!F25","v":12.2125},{"$f":"B34*(1+$B6)","v":12.823125000000001},13.464281250000001,14.137495312500002,14.844370078125003,15.586588582031254,16.365918011132816,17.184213911689458,18.043424607273931,18.945595837637629,19.892875629519512,20.887519410995488,21.931895381545264,23.028490150622527,24.179914658153656]
["Chemical Cost",{"$f":"'WWTP-Capacity & Tech. Selection'!G25","v":26.5},{"$f":"B35*(1+$B7)","v":27.825000000000003},29.216250000000006,30.677062500000009,32.210915625000013,33.821461406250016,35.512534476562521,37.288161200390647,39.152569260410182,41.110197723430694,43.165707609602229,45.323992990082346,47.590192639586462,49.969702271565787,52.468187385144077]
["Manpower Cost",{"$f":"'WWTP-Capacity & Tech. Selection'!H25","v":4},{"$f":"B36*(1+$B8)","v":4.4000000000000004},4.8400000000000007,5.3240000000000016,5.8564000000000025,6.4420400000000031,7.0862440000000042,7.7948684000000057,8.5743552400000063,9.4317907640000076,10.374969840400009,11.412466824440012,12.553713506884014,13.809084857572417,15.189993343329659]
[]
["Net Cost Incurred",{"$f":"SUM(B32:B36)-B37","v":857.18305000000009},{"$f":"SUM(C32:C36)","v":67.009007000000011},71.238283810000013,75.753730577300018,80.576072289109021,85.727627501143999,91.232437001587087,97.1164032670832,103.40744164308744,110.13564426330394,117.33345781281622,125.03587633747586,133.2806504089304,142.10851407114856,151.56343112132623]
["Discounted Cost",{"$f":"B38/(1+$B$5)^B31","v":857.18305000000009},{"$f":"C38/(1+$B$5)^C31","v":60.917279090909098},58.874614719008264,56.914899006235906,55.034541553930062,53.230111890732729,51.4983322626695,49.836070749870849,48.240334695107585,46.708264429986407,45.237127285294328,43.824311872595047,42.467322624765657,41.163774583721612,39.911388424111962]
["Revenue from Industrial Water",{"$f":"'Revenue Earned'!C28*$B$18","v":143.80845432919523},{"$f":"B40*(1+$B10)","v":150.99887704565501},{"$f":"C40*(1+$B10)","v":158.54882089793776},166.47626194283464,174.80007503997638,183.54007879197519,192.71708273157395,202.35293686815265,212.47058371156029,223.09411289713833,234.24881854199526,245.96125946909504,258.25932244254983,271.17228856467733,284.73090299291118]
["Revenue from Agricultural Water",{"$f":"'Revenue Earned'!C27","v":0},{"$f":"B41*(1+$B9)","v":0},{"$f":"C41*(1+$B9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Revenue from Electricity",{"$f":"'Revenue Earned'!C29","v":17.52},{"$f":"B42*(1+$B17)","v":18.921600000000002},20.435328000000002,22.070154240000004,23.835766579200005,25.742627905536008,27.80203813797889,30.026201189017204,32.42829728413858,35.02256106686967,37.824365952219246,40.850315228396788,44.118340446668533,47.647807682402018,51.45963229699418]
["Revenue from Fertiliser",{"$f":"'Revenue Earned'!C30","v":0},{"$f":"B43*(1+$B11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Net Revenue Earned",{"$f":"SUM(B40:B43)","v":161.32845432919524},{"$f":"SUM(C40:C43)","v":169.92047704565502},178.98414889793776,188.54641618283463,198.63584161917638,209.2827066975112,220.51912086955284,232.37913805716985,244.89888099569887,258.11667396400799,272.0731844942145,286.81157469749184,302.37766288921836,318.82009624707933,336.19053528990537]
["Discounted Revenue",{"$f":"B44/(1+$B$5)^B31","v":161.32845432919524},{"$f":"C44/(1+$B$5)^C31","v":154.47316095059546},147.92078421317169,141.65771313511237,{"$f":"F44/(1+$B$5)^F31","v":135.67095254366254},129.94809513601973,124.47729480924041,119.24724120149082,114.2471353895987,109.46666669036291,104.89599051546726,100.52570723212251,96.346841983738173,92.350825427001325,88.529475343723149]
["Net Cash flow",{"$f":"B44-B38","v":-695.85459567080488},{"$f":"C44-C38","v":102.91147004565501},107.74586508793774,112.79268560553461,118.05976933006735,123.5550791963672,129.28668386796573,135.26273479008665,141.49143935261145,147.98102970070403,154.73972668139828,161.77569836001598,169.09701248028796,176.71158217593077,184.62710416857914]
["NPV",{"$f":"NPV(B5,B46:P46)","v":245.49537791960267}]
[]
["Cumulative Cash Flow (discounted)",{"$f":"-B39+B45","v":-695.85459567080488},{"$f":"B49-C39+C45","v":-602.29871381111855},{"$f":"C49-D39+D45","v":-513.2525443169551},{"$f":"D49-E39+E45","v":-428.50973018807866},-347.87331919834617,-271.15533595305914,-198.17637340648827,-128.7652029548683,-62.758402260377181,-6.6791017161449417E-13,59.658863230172265,116.36025858969973,170.23977794867224,221.42682879195195,270.04491571156314]
[null,{"$f":"AND(A49<0,B49>=0)","v":false},{"$f":"AND(B49<0,C49>=0)","v":false},{"$f":"AND(C49<0,D49>=0)","v":false},false,{"$f":"AND(E49<0,F49>=0)","v":false},{"$f":"AND(F49<0,G49>=0)","v":false},false,false,false,false,true,false,false,false,false]
[null,{"$f":"IF(B50=TRUE,B31+ABS(A49/(-B39+B45)),0)","v":0},{"$f":"IF(C50=TRUE,C31+ABS(B49/(-C39+C45)),0)","v":0},{"$f":"IF(D50=TRUE,D31+ABS(C49/(-D39+D45)),0)","v":0},{"$f":"IF(E50=TRUE,E31+ABS(D49/(-E39+E45)),0)","v":0},0,0,0,0,0,0,10.000000000000011,0,0,0,0]
["Discounted Payback Period",{"$f":"MAX(B51:P51)","v":10.000000000000011}]

{"sheet":"Summary Sheet","index":9,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[16,0,16,1],[22,0,22,1],[23,0,23,1],[0,0,0,2],[10,0,10,1],[4,0,4,1],[8,0,8,1],[7,0,7,1],[6,0,6,1],[5,0,5,1],[3,0,3,1]]}
[]
["WW Treatment Capacity",{"$f":"'WWTP-Capacity & Tech. Selection'!B5","v":"Manually planned"},{"$f":"'WWTP-Capacity & Tech. Selection'!C5 & \" MLD\"","v":"50 MLD"}]
[]
[null,null,"million INR"]
["Total CAPEX",null,{"$f":"'WWTP-Capacity & Tech. Selection'!D25","v":794.13640000000009}]
[{"$f":"'WWTP-Capacity & Tech. Selection'!C10","v":"ASP with Tertiary Treatment"},null,{"$f":"'WWTP-Capacity & Tech. Selection'!D10","v":740}]
[{"$f":"'WWTP-Capacity & Tech. Selection'!C11","v":"Biogas to electricity unit"},null,{"$f":"'WWTP-Capacity & Tech. Selection'!D11","v":7.2499999999999991}]
[{"$f":"'WWTP-Capacity & Tech. Selection'!C12","v":0},null,{"$f":"'WWTP-Capacity & Tech. Selection'!D12","v":0}]
["Cost of supply infrastructure",null,{"$f":"SUM('WWTP-Capacity & Tech. Selection'!D19:D24)","v":46.886400000000002}]
[]
["Annual OPEX (year 1)",null,{"$f":"SUM('WWTP-Capacity & Tech. Selection'!E25:H25)","v":63.04665}]
[{"$f":"'WWTP-Capacity & Tech. Selection'!E8","v":"Power Cost"},null,{"$f":"'WWTP-Capacity & Tech. Selection'!E25","v":20.334149999999998}]
[{"$f":"'WWTP-Capacity & Tech. Selection'!F8","v":"Repairs cost"},null,{"$f":"'WWTP-Capacity & Tech. Selection'!F25","v":12.2125}]
[{"$f":"'WWTP-Capacity & Tech. Selection'!G8","v":"Chemical Cost"},null,{"$f":"'WWTP-Capacity & Tech. Selection'!G25","v":26.5}]
[{"$f":"'WWTP-Capacity & Tech. Selection'!H8","v":"Manpower Cost"},null,{"$f":"'WWTP-Capacity & Tech. Selection'!H25","v":4}]
[]
[{"$f":"'Revenue Earned'!A31 & \" (year 1)\"","v":"Annual Revenue (year 1)"},null,{"$f":"'Revenue Earned'!C31","v":161.32845432919524}]
["Annual water sold to agriculture",{"$f":"'Revenue Earned'!B22 & \" MLD\"","v":"19.2 MLD"},{"$f":"'Revenue Earned'!C27","v":0}]
[{"$f":" \"Annual water sold to industry (\" & TEXT('Economic Analysis'!B22,\"0%\") & \" of treated water being sold)\"","v":"Annual water sold to industry (40% of treated water being sold)"},{"$f":"'Revenue Earned'!B23 & \" MLD\"","v":"12.8 MLD"},{"$f":"'Revenue Earned'!C28","v":143.80845432919523}]
["Annual electricity generated/sold",{"$f":"'Revenue Earned'!C10 & \" kWh/d\"","v":"8000 kWh/d"},{"$f":"'Revenue Earned'!C29","v":17.52}]
["Annual MAP eq. fertiliser recovered",{"$f":"'Revenue Earned'!C30/'Revenue Earned'!C15*1000 & \" metric ton\"","v":"0 metric ton"},{"$f":"'Revenue Earned'!C30","v":0}]
[]
["Payback period (years) ",null,{"$f":"'Economic Analysis'!B20","v":10}]
["Tariff for water resale to industry (INR per kl)",null,{"$f":"'Economic Analysis'!B27","v":30.780919162927063}]

{"sheet":"SA NPV WSP","index":10,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$46",2468242668.4344501,2425791819.9306598,2445373780.9431701,2468242668.4344501,2494985630.6789999,2526292569.8468299,634770570.80060899,2468242668.4344501,4301714766.0682898,6135186863.7021303,3013697213.8889899,2740969941.1617198,2468242668.4344501,2195515395.70718,1922788122.9798999,2472682668.4344501,2470462668.4344501,2468242668.4344501,2466022668.4344501,2463802668.4344501,2461582668.4344501,2459362668.4344501,2457142668.4344501,2454922668.4344501,2452702668.4344501,2450482668.4344501,2386304839.2757602,2427273753.8551102,2468242668.4344501,2509211583.0137901,2550180497.5931301,634770570.80060899,1551506619.6175301,2468242668.4344501,3384978717.25137,4301714766.0682898]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA PBP WSP","index":11,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$51",4.1566153364142897,4.16916242113642,4.1629533253973898,4.1566153364142897,4.1501505130449798,4.1435612107396,9.3062033028170905,4.1566153364142897,2.6834327270412501,1.97653281019126,2.2814557614667499,3.1942471681414601,4.1566153364142897,5.1744979549528098,6.2543441039280703,4.1401978278013702,4.14840658210783,4.1566153364142897,4.1648240907207503,4.1730328450272101,4.1812415993336698,4.1894503536401304,4.1976591079465901,4.2058678622530499,4.2140766165595096,4.2222853708659596,4.24951857682872,4.2025874081237902,4.1566153364142897,4.1115732585638201,4.0674332371313398,9.3062033028170905,5.7423713321345797,4.1566153364142897,3.26084097877018,2.6834327270412501]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA NPV WSP with tertiary","index":12,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$46",1162953857.6993001,1120837981.4361,1140265424.61006,1162953857.6993001,1189485795.8937099,1220545697.46562,-303823820.40777302,1162953857.6993001,2629731535.8063698,4096509213.9134402,1717499312.24475,1440226584.9720299,1162953857.6993001,885681130.42657197,608408403.15384495,1167393857.6993001,1165173857.6993001,1162953857.6993001,1160733857.6993001,1158513857.6993001,1156293857.6993001,1154073857.6993001,1151853857.6993001,1149633857.6993001,1147413857.6993001,1145193857.6993001,1081648346.19329,1122301101.94629,1162953857.6993001,1203606613.4523101,1244259369.2053101,-303823820.40777302,429565018.64576298,1162953857.6993001,1896342696.75283,2629731535.8063698]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA PBP WSP with tertiary","index":13,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$51",7.4215808400851602,7.4904994206569997,7.4568878731154502,7.4215808400851602,7.3845899369607899,7.3459438994317496,0,7.4215808400851602,4.40937599587535,3.1370482166406202,4.2913063417441704,5.7873493857248297,7.4215808400851602,9.2135496367256096,11.2049586132333,7.3941039676311604,7.4078424038581598,7.4215808400851602,7.4353192763121596,7.4490577125391502,7.4627961487661496,7.4765345849931499,7.4902730212201503,7.5040114574471497,7.51774989367415,7.5314883299011504,7.6878282213327296,7.5525971547994102,7.4215808400851602,7.2945852586845197,7.1714281205161496,0,11.330029394221601,7.4215808400851602,5.5297392193010397,4.40937599587535]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA NPV ASP","index":14,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$46",2910793178.6518898,2918588166.2368999,2914992451.4664602,2910793178.6518898,2905882533.3755298,2900133833.1554098,1077321081.01805,2910793178.6518898,4744265276.2857304,6577737373.91957,2992611360.4700699,2951702269.5609798,2910793178.6518898,2869884087.7428002,2828974996.8337102,2915233178.6518898,2913013178.6518898,2910793178.6518898,2908573178.6518898,2906353178.6518898,2904133178.6518898,2901913178.6518898,2899693178.6518898,2897473178.6518898,2895253178.6518898,2893033178.6518898,2923702997.39393,2917248088.0229101,2910793178.6518898,2904338269.28087,2897883359.9098501,1077321081.01805,1994057129.83497,2910793178.6518898,3827529227.4688101,4744265276.2857304]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA PBP ASP","index":15,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$51",1.8334027571840401,1.8331236177872701,1.8332631641080499,1.8334027571840401,1.8335423970387501,1.8336820836957,4.10736839407347,1.8334027571840401,1.18225133600939,0,1.5594663703356799,1.6964345637598599,1.8334027571840401,1.9703709506082201,2.11367653793604,1.8185371425910699,1.8259699498875499,1.8334027571840401,1.8408355644805201,1.8482683717770101,1.8557011790735001,1.8631339863699801,1.8705667936664701,1.87799960096295,1.88543240825944,1.89286521555592,1.82750936193052,1.8304513894118699,1.8334027571840401,1.8363635097978099,1.8393336920877299,4.10736839407347,2.5366243653028699,1.8334027571840401,1.4401401749500999,1.18225133600939]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA NPV ASP with tertiary","index":16,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$46",1699222750.7362399,1707352710.5618401,1703602477.9528501,1699222750.7362399,1694101081.40974,1688105343.5936999,232445072.629163,1699222750.7362399,3166000428.8433099,4632778106.9503803,1790131841.64533,1744677296.1907799,1699222750.7362399,1653768205.2816899,1608313659.8271401,1703662750.7362399,1701442750.7362399,1699222750.7362399,1697002750.7362399,1694782750.7362399,1692562750.7362399,1690342750.7362399,1688122750.7362399,1685902750.7362399,1683682750.7362399,1681462750.7362399,1712764887.13095,1705993818.9335899,1699222750.7362399,1692451682.5388801,1685680614.3415201,232445072.629163,965833911.68270004,1699222750.7362399,2432611589.7897701,3166000428.8433099]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA PBP ASP with tertiary","index":17,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$51",3.6736070197858002,3.67099149976079,3.67228376555647,3.6736070197858002,3.6749618090744498,3.6763486901273001,10.9897446834566,3.6736070197858002,2.2185142577925401,1.5931598010324901,3.1930126820707798,3.43330985092829,3.6736070197858002,3.9139041886433099,4.1634004942784397,3.6501347923318002,3.6618709060587999,3.6736070197858002,3.6853431335128,3.6970792472398002,3.7088153609668,3.7205514746938002,3.7322875884208,3.7440237021477998,3.7557598158748098,3.76749592960181,3.6545756767734199,3.6640677697528301,3.6736070197858002,3.6831937791643101,3.6928284036981802,10.9897446834566,5.4814406699212004,3.6736070197858002,2.7654101699203402,2.2185142577925401]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA NPV SBR","index":18,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$46",3037753879.7270002,3036616274.2295599,3037141035.1538701,3037753879.7270002,3038470542.45436,3039309511.4587698,1204281782.0931599,3037753879.7270002,4871225977.3608398,6704698074.9946804,3078662970.6360998,3058208425.18155,3037753879.7270002,3017299334.27246,2996844788.8179102,3042193879.7270002,3039973879.7270002,3037753879.7270002,3035533879.7270002,3033313879.7270002,3031093879.7270002,3028873879.7270002,3026653879.7270002,3024433879.7270002,3022213879.7270002,3019993879.7270002,3033801894.39781,3035777887.0624099,3037753879.7270002,3039729872.3916001,3041705865.0562,1204281782.0931599,2121017830.91008,3037753879.7270002,3954489928.54392,4871225977.3608398]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA PBP SBR","index":19,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$51",1.63404376293662,1.6340741843798801,1.6340589732933499,1.63404376293662,1.6340285533096299,1.6340133444123299,3.54598756090255,1.63404376293662,1.05875160179057,0,1.49965234807523,1.5668480555059201,1.63404376293662,1.7012394703673199,1.7684351777980101,1.61945781471033,1.62675078882348,1.63404376293662,1.64133673704977,1.64862971116291,1.65592268527605,1.6632156593892,1.67050863350234,1.67780160761549,1.68509458172863,1.69238755584178,1.6356309501357,1.63483697797511,1.63404376293662,1.6332513039377801,1.6324595998981899,3.54598756090255,2.2339595302216302,1.63404376293662,1.2874909887439201,1.05875160179057]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA NPV SBR with tertiary","index":20,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$46",1838957146.99141,1838154513.73456,1838524756.8203101,1838957146.99141,1839462785.6686299,1840054717.0771201,372179468.88433802,1838957146.99141,3305734825.0984802,4772512503.2055502,1888957146.99141,1863957146.99141,1838957146.99141,1813957146.99141,1788957146.99141,1843397146.99141,1841177146.99141,1838957146.99141,1836737146.99141,1834517146.99141,1832297146.99141,1830077146.99141,1827857146.99141,1825637146.99141,1823417146.99141,1821197146.99141,1835637479.3148799,1837297313.1531501,1838957146.99141,1840616980.82967,1842276814.6679399,372179468.88433802,1105568307.93787,1838957146.99141,2572345986.04495,3305734825.0984802]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA PBP SBR with tertiary","index":21,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$51",3.2921626867119498,3.2923580561799599,3.2922612357104599,3.2921626867119498,3.29206239540436,3.291960348061,8.9754425503552504,3.2921626867119498,2.01821270506818,1.46333305485155,3.03638147743243,3.1642720820721899,3.2921626867119498,3.4200532913517199,3.5479438959914802,3.2694493153279298,3.2808060010199398,3.2921626867119498,3.30351937240397,3.31487605809598,3.3262327437879899,3.3375894294799999,3.3489461151720099,3.3603028008640199,3.3716594865560299,3.3830161722480399,3.2962548583868099,3.2942075662107602,3.2921626867119498,3.2901202156279998,3.2880801487065199,8.9754425503552504,4.8047191950685404,3.2921626867119498,2.5070908684561499,2.01821270506818]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA NPV MBBR","index":22,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$46",2968890598.34021,2987293040.2106299,2978804260.55268,2968890598.34021,2957297524.8094301,2943725967.3852,1135418500.7063701,2968890598.34021,4802362695.9740496,6635834793.6078901,3009799689.2493,2989345143.7947502,2968890598.34021,2948436052.8856602,2927981507.4311199,2973330598.34021,2971110598.34021,2968890598.34021,2966670598.34021,2964450598.34021,2962230598.34021,2960010598.34021,2957790598.34021,2955570598.34021,2953350598.34021,2951130598.34021,3001823809.4168501,2985357203.87853,2968890598.34021,2952423992.8018899,2935957387.2635698,1135418500.7063701,2052154549.5232899,2968890598.34021,3885626647.1571298,4802362695.9740496]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA PBP MBBR","index":23,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$51",1.5682970543521899,1.56784537705256,1.56807112591945,1.5682970543521899,1.5685231625651099,1.5687494507728801,3.4992475249187098,1.5682970543521899,1.0063504727233299,0,1.43056146192558,1.49942925813888,1.5682970543521899,1.6371648505654901,1.7060326467787901,1.5533481513874901,1.56082260286984,1.5682970543521899,1.5757715058345401,1.58324595731689,1.5907204087992399,1.5981948602815901,1.60566931176394,1.6131437632462899,1.6206182147286401,1.62809266621099,1.55539483390129,1.56181978076145,1.5682970543521899,1.57482729653457,1.58141115971055,3.4992475249187098,2.1605637165367302,1.5682970543521899,1.22865075440734,1.0063504727233299]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA NPV MBBR with tertiary","index":24,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$46",1618033892.4491601,1636771306.5601699,1628128009.0636699,1618033892.4491601,1606229794.8682401,1592411199.8480799,151256214.34208301,1618033892.4491601,3084811570.5562301,4551589248.6632996,1668033892.4491501,1643033892.4491601,1618033892.4491601,1593033892.4491601,1568033892.4491601,1622473892.4491601,1620253892.4491601,1618033892.4491601,1615813892.4491601,1613593892.4491601,1611373892.4491601,1609153892.4491601,1606933892.4491601,1604713892.4491601,1602493892.4491601,1600273892.4491601,1651599421.1784699,1634816656.8138101,1618033892.4491601,1601251128.0845001,1584468363.71984,151256214.34208301,884645053.39561903,1618033892.4491601,2351422731.5026898,3084811570.5562301]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA PBP MBBR with tertiary","index":25,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$51",3.4886491215929598,3.48290173281277,3.4857409044422498,3.4886491215929598,3.49162804030553,3.49467937546649,12.039181456066901,3.4886491215929598,2.0516551213226002,1.4609986733253399,3.2060058428490299,3.3473274822209902,3.4886491215929598,3.6299707609649299,3.7712924003368999,3.4635503984404998,3.47609976001673,3.4886491215929598,3.50119848316919,3.5137478447454198,3.52629720632165,3.5388465678978802,3.55139592947411,3.56394529105035,3.5764946526265802,3.5890440142028099,3.44102123577902,3.4646794244717598,3.4886491215929598,3.5129365203840801,3.53754797935607,12.039181456066901,5.3719280398222597,3.4886491215929598,2.5870947002284401,2.0516551213226002]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA NPV MBR","index":26,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$46",689098822.85055399,729832747.42711198,711042778.53228998,689098822.85055399,663437479.31048596,633396748.82493603,-777678855.25651896,689098822.85055399,2155876500.9576302,3622654179.0647001,730007913.75964403,709553368.30509901,689098822.85055399,668644277.39600801,648189731.94146299,693538822.85055399,691318822.85055399,689098822.85055399,686878822.85055399,684658822.85055399,682438822.85055399,680218822.85055399,677998822.85055399,675778822.85055399,673558822.85055399,671338822.85055399,764186544.10529602,726642683.47792399,689098822.85055399,651554962.22318196,614011101.59581101,-777678855.25651896,-44290016.202982001,689098822.85055399,1422487661.9040899,2155876500.9576302]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA PBP MBR","index":27,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$51",9.5004081807260405,9.3636799397740198,9.4280581532436205,9.5004081807260405,9.5821704155048,9.6751669817580694,0,9.5004081807260405,5.0973737580721599,3.5058540419693398,9.1588069250576591,9.3296075528918507,9.5004081807260405,9.6712088085602304,9.8420094363944202,9.4633330577775006,9.4818706192517705,9.5004081807260405,9.5189457422003105,9.5374833036745805,9.5560208651488505,9.5745584266231205,9.5930959880973905,9.6116335495716605,9.6301711110459305,9.6487086725202094,9.1145503694124095,9.3040034023068205,9.5004081807260405,9.7041544845156906,9.9156617881097002,0,0,9.5004081807260405,6.6232280109767103,5.0973737580721599]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA NPV UASB","index":28,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$46",1883916224.73893,1875297572.53493,1879273231.85359,1883916224.73893,1889345757.9194,1895701899.8993499,417138546.631859,1883916224.73893,3350693902.8460002,4817471580.9530697,1983916224.73893,1933916224.73893,1883916224.73893,1833916224.73893,1783916224.73893,1888356224.73893,1886136224.73893,1883916224.73893,1881696224.73893,1879476224.73893,1877256224.73893,1875036224.73893,1872816224.73893,1870596224.73893,1868376224.73893,1866156224.73893,1865842478.5000701,1874879351.6194999,1883916224.73893,1892953097.8583601,1901989970.9777901,417138546.631859,1150527385.68539,1883916224.73893,2617305063.79247,3350693902.8460002]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"SA PBP UASB","index":29,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","Elec Tariff rate of increase","E1","E2","E3","E4","Industrial Water sale potential","I1","I2","I3","Land Cost Variation","L1","L2","L3","L4","Dist to Industry","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","Elec Tariff Variation","T1","T2","T3","T4","Industrial Water Tariff","W1","W2","W3","W4"]
[null,null,null,null,"Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016\nModified by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016","Created by A on 11-05-2016"]
[null,"Changing Cells:"]
[null,null,"$B$17",0.08,0.04,0.06,0.08,0.1,0.12,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,"$B$22",0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.5,0.75,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"$B$15",1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$16",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,1,1,1,1,1,1,1,1,1,1]
[null,null,"$B$14",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.6,0.8,1,1.2,1.4,1,1,1,1,1]
[null,null,"$B$18",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.5,0.75,1,1.25,1.5]
[null,"Result Cells:"]
[null,null,"$B$51",2.80684320167803,2.8082395776906601,2.8075450179441002,2.80684320167803,2.8061341612077801,2.8054179292078198,7.8114640415027496,2.80684320167803,1.71765055066571,1.23773249024609,2.3103990215898502,2.5586211116339399,2.80684320167803,3.0583023196622898,3.32111621183273,2.7848010800821199,2.7958221408800701,2.80684320167803,2.81786426247599,2.8288853232739499,2.8399063840719001,2.8509274448698601,2.86194850566782,2.8729695664657799,2.8839906272637301,2.8950116880616901,2.8255019253588798,2.81614258613719,2.80684320167803,2.7976031977265898,2.7884220073384198,7.8114640415027496,4.1198354628512099,2.80684320167803,2.1282991196329002,1.71765055066571]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"Tool","index":30,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,"Enter your Desired Payback period",10,"years"]
[]
[null,"Enter the proportion of treated water for sale",0.3]
[]
[]
[null,null,{"$f":"'Revenue Earned'!B19","v":30.780919162927063},"INR/kl"]

{"sheet":"Sheet1","index":31,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Assumptions for Sens Analysis","index":32,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Assumption for sensitivity analysis"]
["Cost of land /m2 in INR",4000]
["Power tariff in INR",6]
["Distance to industry from STP in m",500]
["Water Sale tariff for industries per kL in INR",50]
["Water Sale tariff for agriculture per kL in INR",0]
["Variation in the electricity tariff",1]
["Variation in the cost of land",1]
["Variation in distance of industry from point of STP discharge",1]
["Nominal rate of increase in electricity Tariff",0.08]
["Variation in industrial water sale tariff",1]
["Enter the proportion of treated water for sale",0.5]
["Discount rate",0.1]
["Rate of increase of repair costs",0.05]
["Rate of increase of chemical cost",0.05]
["Rate of increase of manpower cost",0.1]
["Rate of increase of agricultural water tariff",0.04]
["Rate of increase of industrial water tariff",0.05]
["Rate of increase of fertiliser tariff",0.05]

{"sheet":"SA of technologies against NPV","index":33,"n_rows":12,"n_cols":36,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,31,0,35],[0,1,0,5],[0,6,0,9],[0,10,0,14],[0,15,0,25],[0,26,0,30]]}
["NPV","Rate of increase in electricity tariff",null,null,null,null,"Industrial water sale potential",null,null,null,"Land cost ",null,null,null,null,"Distance to industry",null,null,null,null,null,null,null,null,null,null,"Electricity tariff ",null,null,null,null,"Industrial water tariff"]
["% variation",0.04,0.06,0.08,0.1,0.12,0.25,0.5,0.75,1,0.5,0.75,1,1.25,1.5,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,0.6,0.8,1,1.2,1.4,0.5,0.75,1,1.25,1.5]
["Waste Stabilisation Pond (WSP)",2315.9561784774901,2315.3767365829199,2314.7000325752701,2313.9086923872501,2312.9823014025501,481.22793494143298,2314.7000325752701,4148.17213020911,5981.6442278429504,2860.1545780298202,2587.4273053025499,2314.7000325752701,2041.9727598479999,1769.2454871207301,2316.1800325752702,2315.4400325752699,2314.7000325752701,2313.9600325752699,2313.2200325752701,2312.4800325752699,2311.7400325752701,2311.0000325752699,2310.2600325752701,2309.5200325752699,2308.7800325752701,2317.0712237727898,2315.88562817403,2314.7000325752701,2313.5144369765098,2312.32884137776,481.22793494143298,1397.96398375835,2314.7000325752701,3231.4360813921899,4148.17213020911]
["WSP with Tertiary Treatment",1011.00233998294,1010.26838024981,1009.41122184012,1008.40885760196,1007.23542902134,-457.36645626694798,1009.41122184012,2476.1888999471998,3942.96657805427,1563.9566763855801,1286.6839491128501,1009.41122184012,732.13849456739695,454.86576729466998,1010.89122184012,1010.15122184012,1009.41122184012,1008.67122184012,1007.93122184012,1007.19122184012,1006.45122184012,1005.7112218401199,1004.9712218401201,1004.23122184012,1003.49122184012,1012.41473069031,1010.91297626522,1009.41122184012,1007.90946741503,1006.40771298993,-457.36645626694798,276.02238278658803,1009.41122184012,1742.80006089366,2476.1888999471998]
["Activated SludgeProcess (ASP)",2808.7525247837398,2784.9954071062102,2757.2505427927199,2724.8055950837802,2686.8235647111401,923.778445158875,2757.2505427927199,4590.7226404265502,6424.1947380603997,2839.0687246109001,2798.15963370181,2757.2505427927199,2716.3414518836198,2675.4323609745302,2758.7305427927199,2757.9905427927201,2757.2505427927199,2756.5105427927201,2755.7705427927199,2755.0305427927201,2754.2905427927199,2753.5505427927201,2752.8105427927198,2752.0705427927201,2751.3305427927198,2854.46938189096,2805.8599623418399,2757.2505427927199,2708.6411232435898,2660.0317036944698,923.778445158875,1840.5144939757899,2757.2505427927199,3673.9865916096401,4590.7226404265502]
["ASP with Tertiary Treatment",1597.5170691086701,1573.6054335925901,1545.6801148770601,1513.02414311799,1474.79507514942,78.902436769987702,1545.6801148770601,3012.4577929841298,4479.2354710912095,1636.5892057861499,1591.1346603316099,1545.6801148770601,1500.22556942251,1454.77102396797,1547.1601148770601,1546.4201148770601,1545.6801148770601,1544.9401148770601,1544.2001148770601,1543.4601148770601,1542.72011487706,1541.98011487706,1541.24011487706,1540.50011487706,1539.76011487706,1643.53127162798,1594.60569325252,1545.6801148770601,1496.7545365015999,1447.8289581261399,78.902436769987702,812.29127582352396,1545.6801148770601,2279.0689539305999,3012.4577929841298]
["Sequencing Batch Reactor (SBR)",2926.7806327764001,2907.1439907936201,2884.21124386783,2857.3936041626098,2825.9992430144898,1050.7391462339899,2884.21124386783,4717.6833415016699,6551.1554391355103,2925.1203347769201,2904.6657893223801,2884.21124386783,2863.75669841328,2843.30215295874,2885.6912438678301,2884.9512438678298,2884.21124386783,2883.4712438678298,2882.73124386783,2881.9912438678298,2881.25124386783,2880.5112438678302,2879.77124386783,2879.0312438678302,2878.29124386783,2964.5682788948302,2924.3897613813301,2884.21124386783,2844.03272635433,2803.8542088408199,1050.7391462339899,1967.4751950509101,2884.21124386783,3800.9472926847502,4717.6833415016699]
["SBR with Tertiary Treatment",1728.3188722814,1708.52771246006,1685.41451113223,1658.3858473768801,1626.74444863284,218.63683302516199,1685.41451113223,3152.1921892393102,4618.9698673463799,1735.41451113223,1710.41451113223,1685.41451113223,1660.41451113223,1635.41451113223,1686.89451113223,1686.15451113223,1685.41451113223,1684.67451113223,1683.93451113223,1683.19451113223,1682.45451113223,1681.71451113223,1680.97451113223,1680.23451113223,1679.4945111322299,1766.40386381191,1725.90918747207,1685.41451113223,1644.9198347924,1604.42515845256,218.63683302516199,952.02567207869799,1685.41451113223,2418.8033501857699,3152.1921892393102]
["Moving Bed Biological Reactor (MBBR)",2877.4573987574699,2848.8072161924301,2815.3479624810302,2776.2205865176902,2730.4156989409198,981.87586484719304,2815.3479624810302,4648.8200601148701,6482.2921577487105,2856.2570533901198,2835.8025079355798,2815.3479624810302,2794.8934170264902,2774.4388715719401,2816.8279624810302,2816.08796248103,2815.3479624810302,2814.60796248103,2813.8679624810302,2813.12796248103,2812.3879624810302,2811.6479624810299,2810.9079624810302,2810.1679624810299,2809.4279624810301,2932.5901939138798,2873.96907819746,2815.3479624810302,2756.7268467646099,2698.1057310481901,981.87586484719304,1898.61191366411,2815.3479624810302,3732.0840112979499,4648.8200601148701]
["MBBR with Tertiary Treatment",1526.93566510701,1498.13096470341,1464.4912565899799,1425.15285657649,1379.1009314037999,-2.2864215170925202,1464.4912565899799,2931.2689346970501,4398.0466128041298,1514.4912565899799,1489.4912565899799,1464.4912565899799,1439.4912565899799,1414.4912565899799,1465.9712565899799,1465.2312565899799,1464.4912565899799,1463.7512565899799,1463.0112565899799,1462.2712565899801,1461.5312565899801,1460.7912565899801,1460.0512565899801,1459.3112565899801,1458.5712565899801,1582.36580567549,1523.4285311327401,1464.4912565899799,1405.55398204722,1346.61670750447,-2.2864215170925202,731.102417536443,1464.4912565899799,2197.8800956435198,2931.2689346970501]
["Membrane Bioreactor (MBR)",619.99710597395006,581.04573417203505,535.55618699137801,482.36054101873799,420.08648038065797,-931.22149111569399,535.55618699137801,2002.3338650984499,3469.1115432055199,576.465277900469,556.01073244592396,535.55618699137801,515.10164153683297,494.64709608228702,537.03618699137803,536.29618699137802,535.55618699137801,534.816186991378,534.07618699137799,533.33618699137799,532.59618699137798,531.85618699137797,531.11618699137796,530.37618699137795,529.63618699137805,694.952928602322,615.25455779685001,535.55618699137801,455.85781618590602,376.15944538043499,-931.22149111569399,-197.83265206215799,535.55618699137801,1268.94502604491,2002.3338650984499]
["Upstream Anaerobic Sludge Blanket ",1765.46193108177,1749.2761874933401,1730.3735888797601,1708.2688196276499,1682.39163145507,263.595910772683,1730.3735888797601,3197.1512669868298,4663.9289450939004,1830.3735888797601,1780.3735888797601,1730.3735888797601,1680.3735888797601,1630.3735888797601,1731.8535888797601,1731.1135888797601,1730.3735888797601,1729.6335888797601,1728.89358887976,1728.15358887976,1727.41358887976,1726.67358887976,1725.93358887976,1725.19358887976,1724.45358887975,1796.6088629971,1763.49122593843,1730.3735888797601,1697.2559518210801,1664.1383147624099,263.595910772683,996.98474982621894,1730.3735888797601,2463.7624279332899,3197.1512669868298]

{"sheet":"SA of technologies against PBP","index":34,"n_rows":12,"n_cols":36,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,31,0,35],[0,1,0,5],[0,6,0,9],[0,10,0,14],[0,15,0,25],[0,26,0,30]]}
["NPV","Rate of increase in electricity tariff",null,null,null,null,"Industrial water sale potential",null,null,null,"Land cost ",null,null,null,null,"Distance to industry",null,null,null,null,null,null,null,null,null,null,"Electricity tariff ",null,null,null,null,"Industrial water tariff"]
["% variation",0.04,0.06,0.08,0.1,0.12,0.25,0.5,0.75,1,0.5,0.75,1,1.25,1.5,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,0.6,0.8,1,1.2,1.4,0.5,0.75,1,1.25,1.5]
["Waste Stabilisation Pond (WSP)",4.0980531474878896,4.0982361444228301,4.0984241176860898,4.0986171564075597,4.0988153505700398,9.5934894411626299,4.0984241176860898,2.6165141524761402,1.9185863440223601,2.17898608807978,3.1167191077037799,4.0984241176860898,5.12849339428164,6.2116461207099301,4.0928662757623204,4.0956451967242096,4.0984241176860898,4.1012030386479701,4.1039819596098601,4.1067608805717404,4.1095398015336304,4.1123187224955098,4.1150976434573998,4.1178765644192801,4.1206554853811603,4.0957452463182999,4.0970842633833202,4.0984241176860898,4.0997648100121102,4.1011063411478501,9.5934894411626299,5.7362610186833898,4.0984241176860898,3.1924020771199801,2.6165141524761402]
["WSP with Tertiary Treatment",7.4649786340778803,7.4663074549302602,7.4677304005188496,7.4692538666756798,7.4708846477274298,15,7.4677304005188496,4.3526764913216001,3.0727652814544402,4.2441836517746498,5.7933880506932898,7.4677304005188496,9.2830771326194998,11.271002387296599,7.4584246480915599,7.4630775243052101,7.4677304005188496,7.4723832767324998,7.4770361529461402,7.4816890291597904,7.4863419053734299,7.4909947815870801,7.4956476578007196,7.5003005340143698,7.5049534102280102,7.4576951265189404,7.4627096167826004,7.4677304005188496,7.4727574895831204,7.47779089586066,15,11.718113658916099,7.4677304005188496,5.4968400924762202,4.3526764913216001]
["Activated SludgeProcess (ASP)",1.71014883917769,1.7109785926385499,1.7118102873718799,1.7126439301983001,1.7134795279704,4.0620046680661597,1.7118102873718799,1.08400843239714,0,1.42519316184809,1.5685017246099899,1.7118102873718799,1.8551188501337801,1.99842741289568,1.70662570203463,1.70921799470326,1.7118102873718799,1.71440258004051,1.71699487270914,1.7195871653777599,1.7221794580463901,1.72477175071502,1.7273640433836399,1.7299563360522701,1.7325486287209,1.6691668060810501,1.69022253458796,1.7118102873718799,1.7339504867772,1.75666461394183,4.0620046680661597,2.4069436620918898,1.7118102873718799,1.3297448106678,1.08400843239714]
["ASP with Tertiary Treatment",3.5828258579764798,3.59121694044511,3.59988021203666,3.6088274625786099,3.6180712186586499,12.717195655187201,3.59988021203666,2.1188657655876,1.50710007367025,3.0930923140357098,3.3464862630361898,3.59988021203666,3.8532741610371399,4.1121683916003002,3.5916297050572101,3.5957549585469302,3.59988021203666,3.6040054655263898,3.60813071901612,3.6122559725058401,3.6163812259955699,3.6205064794853001,3.6246317329750299,3.6287569864647602,3.6328822399544798,3.4604888661798401,3.5288510442174998,3.59988021203666,3.6737355440570001,3.7505891385229799,12.717195655187201,5.55317058389869,3.59988021203666,2.6684926430596798,2.1188657655876]
["Sequencing Batch Reactor (SBR)",1.5047384867498701,1.50521637177559,1.50569516257938,1.5061748617388899,1.5066554718415499,3.4492594012334301,1.50569516257938,0,0,1.3652329112418999,1.43546403691064,1.50569516257938,1.57592628824812,1.64615741391686,1.5006135504643301,1.5031543565218499,1.50569516257938,1.50823596863691,1.5107767746944301,1.5133175807519601,1.5158583868094899,1.51839919286701,1.52093999892454,1.5234808049820701,1.5260216110395901,1.47512007826224,1.4902527361364,1.50569516257938,1.5214569674873599,1.5375481624115199,3.4492594012334301,2.0900008742748,1.50569516257938,1.17365553572032,0]
["SBR with Tertiary Treatment",3.18923310028176,3.19433880093223,3.1995720640982799,3.2049376142903898,3.2104404504400601,9.9232439429126096,3.1995720640982799,1.9184959019915799,1.37521597557157,2.9339387600734899,3.06508842086199,3.1995720640982799,3.33405570733456,3.4685393505708402,3.1916106324186901,3.1955913482584801,3.1995720640982799,3.2035527799380699,3.2075334957778701,3.21151421161766,3.21549492745745,3.2194756432972498,3.2234563591370402,3.22743707497684,3.2314177908166299,3.0994912443307898,3.1487640188344201,3.1995720640982799,3.2519882710474102,3.3060902190508599,9.9232439429126096,4.8132865970922101,3.1995720640982799,2.4014416274888002,1.9184959019915799]
["Moving Bed Biological Reactor (MBBR)",1.43244603152846,1.4330588360429799,1.4336733797908501,1.4342896701868899,1.4349077146881699,3.3944779954019202,1.4336733797908501,0,0,1.28951597038395,1.3615946750874,1.4336733797908501,1.5057520844943,1.5778307891977501,1.42845808506831,1.4310657324295799,1.4336733797908501,1.43628102715212,1.43888867451339,1.4414963218746599,1.4441039692359401,1.44671161659721,1.44931926395848,1.4519269113197499,1.4545345586810201,1.39048453518438,1.4117529964241899,1.4336733797908501,1.45627612595208,1.4795936007236401,3.3944779954019202,2.0073270516342601,1.4336733797908501,1.1105165417521901,0]
["MBBR with Tertiary Treatment",3.38259618137891,3.3921332970078701,3.4019878318859198,3.41217599640111,3.4227151873769901,15,3.4019878318859198,1.94551643002985,1.3688974177948701,3.1021366707071101,3.25206225129652,3.4019878318859198,3.5519134124753302,3.7018389930647402,3.3931122375150302,3.3975500347004801,3.4019878318859198,3.4064256290713701,3.41086342625682,3.4153012234422602,3.4197390206277101,3.42417681781316,3.4286146149986001,3.43305241218405,3.4374902093694999,3.2328589888225698,3.3153384763651701,3.4019878318859198,3.4931314765959698,3.5891283815772699,15,5.4572366868735402,3.4019878318859198,2.4779701832915602,1.94551643002985]
["Membrane Bioreactor (MBR)",9.3754544165231906,9.5173566973237094,9.6826791789587308,9.8780057433336008,10.1210538588868,15,9.6826791789587308,5.0509022553427299,3.4425230584008801,9.3340619416049506,9.5083705602818398,9.6826791789587308,9.8569877976356199,10.0330654338767,9.6700669820162393,9.6763730804874797,9.6826791789587308,9.6889852774299694,9.6952913759012205,9.7015974743724591,9.7079035728436995,9.7142096713149506,9.7205157697861893,9.7268218682574297,9.7331279667286807,8.8456402814602608,9.2424362366259292,9.6826791789587308,10.1724792370269,10.7305948166509,15,12,9.6826791789587308,6.6236034886259603,5.0509022553427299]
["Upstream Anaerobic Sludge Blanket ",2.68462381244689,2.6873852186872398,2.6901893840369002,2.6930369765095099,2.6959286818666799,8.5921486296630398,2.6901893840369002,1.60555654231828,1.1427685717481799,2.1628387566750198,2.4265140703559598,2.6901893840369002,2.9538646977178402,3.22853351849266,2.6823845947519498,2.6862869893944201,2.6901893840369002,2.6940917786793799,2.69799417332186,2.7018965679643401,2.70579896260681,2.7097013572492901,2.7136037518917702,2.7175061465342498,2.7214085411767299,2.6220527040277801,2.6556930781657102,2.6901893840369002,2.72557470953697,2.7618838702700299,8.5921486296630398,4.0740638547887702,2.6901893840369002,2.00466985470214,1.60555654231828]